//author:kakake
class tsFrontController {
    public data = {
        dbConn: TSLobsterAPI.Program.GetDbConn()
    }

    getPositionList() {

        var strsql = "select * from BasePosition where DelFlag=0";
        var strsql2 = "select * from BaseSymptomClass where DelFlag=0";
        var strsql3 = "select a.*,b.Name from BaseSymptom a\
        left join BaseDept b on a.DeptCode = b.Code  where a.DelFlag=0 and b.DelFlag=0";

        var res = TSLobsterAPI.DbHelper.DbGetJsonData(this.data.dbConn, strsql);
        var res2 = TSLobsterAPI.DbHelper.DbGetJsonData(this.data.dbConn, strsql2);
        var res3 = TSLobsterAPI.DbHelper.DbGetJsonData(this.data.dbConn, strsql3);
        return {
            positionList: res,
            symptomClassList: res2,
            symptomList: res3
        }
    }

}